﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="UserCurrencyList.ascx.cs" Inherits="UserCurrencyList" %>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataSourceID="SqlDataSourceCurrencyList">
    <Columns>
        <asp:BoundField DataField="Валюта" HeaderText="Валюта" 
            SortExpression="Валюта" />
        <asp:BoundField DataField="Курс" HeaderText="Курс" ReadOnly="True" 
            SortExpression="Курс" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSourceCurrencyList" runat="server" 
    ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>" 
    SelectCommand="SELECT Name AS Валюта, ROUND((SELECT USDExchangeRate FROM Currency WHERE (CurrencyID = 13)) / USDExchangeRate, 2) AS Курс FROM Currency AS Currency_1 WHERE (CurrencyID &lt;&gt; 13)">
</asp:SqlDataSource>

